//add counties to Delaware, using census block assignments file.

replace sldl=42 if county=="Adams" & sldl==41

replace sldl=89 if county=="Brown" & sldl==6

replace sldl=91 if county=="Buffalo" 

replace sldl=28 if fcounty==13 & mcd=="Roosevelt"

replace sldl=27 if county=="Calumet" & sldl==59

replace sldl=28 if fcounty==13 & sldl==25

replace sldl=68 if fcounty==17 & sldl==91 & mcd=="Eau Claire"

replace sldl=69 if fcounty==19 & (sldl==68 | sldl==87)

replace sldl=42 if fcounty==21 & sldl==41
replace sldl=38 if fcounty==21 & sldl==37
replace sldl=42 if fcounty==21 & sldl==81
replace sldl=47 if fcounty==21 & mcd=="West Point"

replace sldl=82 if fcounty==79 & mcd=="Franklin"
replace sldl=84 if fcounty==79 & mcd=="Hales Corner"
replace sldl=84 if fcounty==79 & mcd=="Hales Corners"

replace sldl=92 if fcounty==81 & sldl==70
replace sldl=66 if fcounty==101 & sldl==67

replace sldl=43 if fcounty==105 & mcd=="Beloit"
replace sldl=45 if fcounty==105 & mcd=="Bradford"
replace sldl=45 if fcounty==105 & mcd=="Clinton"
replace sldl=45 if fcounty==105 & mcd=="Harmony"
replace sldl=43 if fcounty==105 & mcd=="Janesville"
replace sldl=45 if fcounty==105 & mcd=="Johnstown"
replace sldl=45 if fcounty==105 & mcd=="La Prairie"
replace sldl=45 if fcounty==105 & mcd=="Turtle"

replace sldl=74 if fcounty==113 & sldl==72

replace sldl=98 if fcounty==133 & sldl==13
replace sldl=14 if fcounty==133 & mcd=="Elm Grove"

replace sldl=80 if fcounty==25 & mcd=="Oregon"
replace sldl=46 if fcounty==25 & mcd=="Rutland"
replace sldl=37 if fcounty==25 & mcd=="Albion"
replace sldl=43 if fcounty==25 & mcd=="Edgerton"
replace sldl=46 if fcounty==25 & mcd=="Dunkirk"
replace sldl=47 if fcounty==25 & mcd=="Dane"
replace sldl=47 if fcounty==25 & mcd=="DeForest"
replace sldl=47 if fcounty==25 & mcd=="Windsor"
replace sldl=47 if fcounty==25 & mcd=="Marshall"
replace sldl=37 if fcounty==25 & mcd=="Deerfield"
replace sldl=37 if fcounty==25 & mcd=="Cambridge"
replace sldl=47 if fcounty==25 & mcd=="Medina"
replace sldl=37 if fcounty==25 & mcd=="Christiana"
replace sldl=37 if fcounty==25 & mcd=="Rockdale"


replace sldl=80 if fcounty==25 & mcd=="Belleville"
replace sldl=79 if fcounty==25 & mcd=="Blue Mounds"
replace sldl=80 if fcounty==25 & mcd=="Brooklyn"
replace sldl=79 if fcounty==25 & mcd=="Cross Plains"
replace sldl=80 if fcounty==25 & mcd=="Montrose"
replace sldl=79 if fcounty==25 & mcd=="Mount Horeb"
replace sldl=80 if fcounty==25 & mcd=="Perry"
replace sldl=80 if fcounty==25 & mcd=="Primrose"
replace sldl=79 if fcounty==25 & mcd=="Springdale"
replace sldl=79 if fcounty==25 & mcd=="Vermont"
replace sldl=79 if fcounty==25 & mcd=="Verona"

replace sldl=38 if fcounty==27 & sldl==37
replace sldl=39 if fcounty==27 & sldl==42

replace sldl=73 if fcounty==31

replace sldl=67 if fcounty==33 & mcd=="New Haven"
replace sldl=93 if fcounty==33 & mcd=="Dunn"
replace sldl=93 if fcounty==33 & mcd=="Eau Galle"
replace sldl=93 if fcounty==33 & mcd=="Peru"
replace sldl=93 if fcounty==33 & mcd=="Rock Creek"
replace sldl=93 if fcounty==33 & mcd=="Weston"

replace sldl=92 if fcounty==35 & sldl==91

replace sldl=36 if fcounty==37

replace sldl=41 if fcounty==39 & sldl==42
replace sldl=53 if fcounty==39 & mcd=="Waupun"

replace sldl=36 if fcounty==41 
replace sldl=80 if fcounty==45
replace sldl=41 if fcounty==47

replace sldl=51 if  fcounty==49 & sldl==81
replace sldl=51 if  fcounty==49 & sldl==80

replace sldl=92 if fcounty==53 & (sldl==70 | sldl==68)

replace sldl=31 if fcounty==55 & mcd=="Cold Spring"
replace sldl=37 if fcounty==55 & mcd=="Koshkonong"
replace sldl=37 if fcounty==55 & mcd=="Sumner"
replace sldl=43 if fcounty==55 & mcd=="Whitewater"

replace sldl=37 if fcounty==55 & mcd=="Fort Atkinson"
replace sldl=31 if fcounty==55 & mcd=="Hebron"
replace sldl=37 if fcounty==55 & mcd=="Jefferson"
replace sldl=37 if fcounty==55 & mcd=="Oakland"
replace sldl=31 if fcounty==55 & mcd=="Palmyra"
replace sldl=31 if fcounty==55 & mcd=="Sullivan"


replace sldl=50 if (fcounty==57 & sldl==41) 

replace sldl=66 if fcounty==59 & mcd=="Genoa City"
replace sldl=32 if fcounty==59 & mcd=="Wheatland"

replace sldl=66 if fcounty==59 & mcd=="Brighton"
replace sldl=66 if fcounty==59 & mcd=="Bristol"
replace sldl=64 if fcounty==59 & mcd=="Kenosha"
replace sldl=66 if fcounty==59 & mcd=="Paddock Lake"
replace sldl=66 if fcounty==59 & mcd=="Paris"
replace sldl=65 if fcounty==59 & mcd=="Pleasant Prairie"
replace sldl=66 if fcounty==59 & mcd=="Randall"
replace sldl=66 if fcounty==59 & mcd=="Salem"
replace sldl=66 if fcounty==59 & mcd=="Silver Lake"
replace sldl=64 if fcounty==59 & mcd=="Somers"
replace sldl=66 if fcounty==59 & mcd=="Twin Lakes"

replace sldl=25 if fcounty==71 & mcd=="Centerville"
replace sldl=25 if fcounty==71 & mcd=="Cleveland"
replace sldl=27 if fcounty==71 & mcd=="Kiel"
replace sldl=25 if fcounty==71 & mcd=="Meeme"
replace sldl=27 if fcounty==71 & mcd=="Schleswig"
replace sldl=2  if fcounty==71 & mcd=="Two Creeks"

replace sldl=35 if fcounty==73 & mcd=="Athens"
replace sldl=87 if fcounty==73 & mcd=="Bern"
replace sldl=35 if fcounty==73 & mcd=="Halsey"
replace sldl=85 if fcounty==73 & mcd=="Holton"
replace sldl=87 if fcounty==73 & mcd=="Johnson"
replace sldl=86 if fcounty==73 & mcd=="Rib Falls"
replace sldl=86 if fcounty==73 & mcd=="Rietbrock"


replace sldl=41 if fcounty==77 & mcd=="Crystal Lake"
replace sldl=42 if fcounty==77 & mcd=="Harris"
replace sldl=41 if fcounty==77 & mcd=="Mecan"
replace sldl=42 if fcounty==77 & mcd=="Montello"
replace sldl=41 if fcounty==77 & mcd=="Neshkoro"
replace sldl=41 if fcounty==77 & mcd=="Newton"
replace sldl=42 if fcounty==77 & mcd=="Oxford"
replace sldl=42 if fcounty==77 & mcd=="Packwaukee"
replace sldl=42 if fcounty==77 & mcd=="Shields"
replace sldl=72 if fcounty==77 & mcd=="Springfield"
replace sldl=42 if fcounty==77 & mcd=="Westfield"

replace sldl=23 if fcounty==79 & mcd=="Brown Deer"
replace sldl=10 if fcounty==79 & mcd=="Glendale"
replace sldl=22 if fcounty==79 & mcd=="River Hills"

replace sldl=92 if fcounty==81 & mcd=="Adrian"
replace sldl=92 if fcounty==81 & mcd=="Angelo"
replace sldl=96 if fcounty==81 & mcd=="Cashton"
replace sldl=96 if fcounty==81 & mcd=="Jefferson"
replace sldl=94 if fcounty==81 & mcd=="Leon"
replace sldl=94 if fcounty==81 & mcd=="Melvina"
replace sldl=96 if fcounty==81 & mcd=="Norwalk"
replace sldl=94 if fcounty==81 & mcd=="Portland"
replace sldl=96 if fcounty==81 & mcd=="Ridgeville"
replace sldl=96 if fcounty==81 & mcd=="Sheldon"
replace sldl=92 if fcounty==81 & mcd=="Tomah"
replace sldl=96 if fcounty==81 & mcd=="Wellington"
replace sldl=96 if fcounty==81 & mcd=="Wells"
replace sldl=96 if fcounty==81 & mcd=="Wilton"

replace sldl=92 if fcounty==81 & mcd=="Byron"
replace sldl=92 if fcounty==81 & mcd=="Grant"
replace sldl=92 if fcounty==81 & mcd=="Greenfield"
replace sldl=92 if fcounty==81 & mcd=="La Grange"
replace sldl=92 if fcounty==81 & mcd=="Lafayette"
replace sldl=92 if fcounty==81 & mcd=="Lincoln"
replace sldl=92 if fcounty==81 & mcd=="Little Falls"
replace sldl=92 if fcounty==81 & mcd=="New Lyme"
replace sldl=92 if fcounty==81 & mcd=="Oakdale"
replace sldl=92 if fcounty==81 & mcd=="Scott"
replace sldl=92 if fcounty==81 & mcd=="Sparta"

replace sldl=34 if fcounty==85 & mcd=="Enterprise"
replace sldl=35 if fcounty==85 & mcd=="Little Rice"
replace sldl=35 if fcounty==85 & mcd=="Lynne"
replace sldl=35 if fcounty==85 & mcd=="Nokomis"
replace sldl=34 if fcounty==85 & mcd=="Schoepke"
replace sldl=35 if fcounty==85 & mcd=="Woodboro"

replace sldl=56 if fcounty==87 & sldl==55
replace sldl=23 if fcounty==89 & sldl==24

replace sldl=91 if fcounty==91 & mcd=="Albany"
replace sldl=91 if fcounty==91 & mcd=="Durand"
replace sldl=91 if fcounty==91 & mcd=="Frankfort"
replace sldl=93 if fcounty==91 & mcd=="Lima"
replace sldl=91 if fcounty==91 & mcd=="Pepin"
replace sldl=91 if fcounty==91 & mcd=="Stockholm"
replace sldl=91 if fcounty==91 & mcd=="Waterville"
replace sldl=91 if fcounty==91 & mcd=="Waubeek"

replace sldl=91 if fcounty==93 & mcd=="Bay City"
replace sldl=30 if fcounty==93 & mcd=="Clifton"
replace sldl=30 if fcounty==93 & mcd=="Diamond Bluff"
replace sldl=91 if fcounty==93 & mcd=="El Paso"
replace sldl=91 if fcounty==93 & mcd=="Ellsworth"
replace sldl=29 if fcounty==93 & mcd=="Elmwood"
replace sldl=29 if fcounty==93 & mcd=="Gilman"
replace sldl=91 if fcounty==93 & mcd=="Hartland"
replace sldl=91 if fcounty==93 & mcd=="Isabelle"
replace sldl=91 if fcounty==93 & mcd=="Maiden Rock"
replace sldl=91 if fcounty==93 & mcd=="Martell"
replace sldl=30 if fcounty==93 & mcd=="Oak Grove"
replace sldl=91 if fcounty==93 & mcd=="Plum City"
replace sldl=30 if fcounty==93 & mcd=="Prescott"
replace sldl=93 if fcounty==93 & mcd=="Rock Elm"
replace sldl=91 if fcounty==93 & mcd=="Salem"
replace sldl=29 if fcounty==93 & mcd=="Spring Lake"
replace sldl=29 if fcounty==93 & mcd=="Spring Valley"
replace sldl=30 if fcounty==93 & mcd=="Trenton"
replace sldl=30 if fcounty==93 & mcd=="Trimbelle"
replace sldl=91 if fcounty==93 & mcd=="Union"

replace sldl=87 if fcounty==99 

replace sldl=66 if (fcounty==101 & sldl==32) 

replace sldl=62 if (fcounty==101 & sldl==64) 

replace sldl=96 if fcounty==103 & mcd=="Akan"
replace sldl=96 if fcounty==103 & mcd=="Bloom"
replace sldl=49 if fcounty==103 & mcd=="Boaz"
replace sldl=49 if fcounty==103 & mcd=="Dayton"
replace sldl=49 if fcounty==103 & mcd=="Eagle"
replace sldl=96 if fcounty==103 & mcd=="Forest"
replace sldl=49 if fcounty==103 & mcd=="Richwood"
replace sldl=96 if fcounty==103 & mcd=="Sylvan"
replace sldl=96 if fcounty==103 & mcd=="Viola"
replace sldl=96 if fcounty==103 & mcd=="Yuba"
replace sldl=51 if fcounty==103 & mcd=="Buena Vista"
replace sldl=51 if fcounty==103 & mcd=="Ithaca"
replace sldl=51 if fcounty==103 & mcd=="Lone Rock"
replace sldl=49 if fcounty==103 & mcd=="Orion"
replace sldl=50 if fcounty==103 & mcd=="Willow"

replace sldl=29  if fcounty==109 & (sldl==75 |sldl==93) 

replace sldl=42 if (fcounty==111 & sldl==41) 

replace sldl=42 if fcounty==111 & mcd=="Baraboo"
replace sldl=42 if fcounty==111 & mcd=="Delton"
replace sldl=42 if fcounty==111 & mcd=="Fairfield"
replace sldl=50 if fcounty==111 & mcd=="Freedom"
replace sldl=42 if fcounty==111 & mcd=="Greenfield"
replace sldl=51 if fcounty==111 & mcd=="Honey Creek"
replace sldl=47 if fcounty==111 & mcd=="Merrimac"
replace sldl=51 if fcounty==111 & mcd=="North Freedom"
replace sldl=51 if fcounty==111 & mcd=="Prairie du Sac"
replace sldl=51 if fcounty==111 & mcd=="Sauk City"
replace sldl=51 if fcounty==111 & mcd=="Sumpter"
replace sldl=51 if fcounty==111 & mcd=="Troy"
replace sldl=42 if fcounty==111 & mcd=="West Baraboo"
replace sldl=42 if fcounty==111 & mcd=="Wisconsin Dells"

replace sldl=74 if fcounty==113 & mcd=="Bass Lake"
replace sldl=74 if fcounty==113 & mcd=="Couderay"
replace sldl=87 if fcounty==113 & mcd=="Draper"
replace sldl=74 if fcounty==113 & mcd=="Edgewater"
replace sldl=87 if fcounty==113 & mcd=="Exeland"
replace sldl=74 if fcounty==113 & mcd=="Hayward"
replace sldl=74 if fcounty==113 & mcd=="Hunter"
replace sldl=87 if fcounty==113 & mcd=="Meadowbrook"
replace sldl=87 if fcounty==113 & mcd=="Meteor"
replace sldl=74 if fcounty==113 & mcd=="Ojibwa"
replace sldl=74 if fcounty==113 & mcd=="Radisson"
replace sldl=74 if fcounty==113 & mcd=="Round Lake"
replace sldl=74 if fcounty==113 & mcd=="Sand Lake"
replace sldl=87 if fcounty==113 & mcd=="Weirgor"
replace sldl=74 if fcounty==113 & mcd=="Winter"

replace sldl=40 if (fcounty==115 & sldl==40) 

replace sldl=91 if fcounty==121
replace sldl=96 if fcounty==123
replace sldl=34 if fcounty==125

replace sldl=66 if (fcounty==127 & sldl==63) 

replace sldl=83 if fcounty==127 & mcd=="East Troy"
replace sldl=31 if fcounty==127 & mcd=="La Grange"
replace sldl=83 if fcounty==127 & mcd=="Mukwonago"
replace sldl=31 if fcounty==127 & mcd=="Troy"

replace sldl=32 if fcounty==127 & mcd=="Bloomfield"
replace sldl=32 if fcounty==127 & mcd=="Delavan"
replace sldl=31 if fcounty==127 & mcd=="Elkhorn"
replace sldl=32 if fcounty==127 & mcd=="Geneva"
replace sldl=32 if fcounty==127 & mcd=="Genoa City"
replace sldl=31 if fcounty==127 & mcd=="Lafayette"
replace sldl=32 if fcounty==127 & mcd=="Lake Geneva"
replace sldl=32 if fcounty==127 & mcd=="Linn"
replace sldl=32 if fcounty==127 & mcd=="Lyons"
replace sldl=31 if fcounty==127 & mcd=="Spring Prairie"

replace sldl=58 if fcounty==131 & sldl==39
replace sldl=99 if (fcounty==131 & sldl==22) 
replace sldl=84 if (fcounty==133 & sldl==15) 
replace sldl=98 if (fcounty==133 & sldl==14) 

replace sldl=24 if fcounty==133 & mcd=="Butler"
replace sldl=99 if fcounty==133 & mcd=="Lannon"
replace sldl=99 if fcounty==133 & mcd=="Lisbon"
replace sldl=99 if fcounty==133 & mcd=="Menomonee Falls"
replace sldl=12 if fcounty==133 & mcd=="Milwaukee"

replace sldl=40 if fcounty==135 & mcd=="Bear Creek"
replace sldl=40 if fcounty==135 & mcd=="Clintonville"
replace sldl=6 if fcounty==135 & mcd=="Embarrass"
replace sldl=40 if fcounty==135 & mcd=="Lebanon"
replace sldl=6 if fcounty==135 & mcd=="Matteson"

replace sldl=41 if fcounty==137 & mcd=="Aurora"
replace sldl=41 if fcounty==137 & mcd=="Bloomfield"
replace sldl=41 if fcounty==137 & mcd=="Leon"
replace sldl=41 if fcounty==137 & mcd=="Lohrville"
replace sldl=41 if fcounty==137 & mcd=="Mount Morris"
replace sldl=41 if fcounty==137 & mcd=="Poysippi"
replace sldl=41 if fcounty==137 & mcd=="Redgranite"
replace sldl=41 if fcounty==137 & mcd=="Saxeville"
replace sldl=41 if fcounty==137 & mcd=="Springwater"
replace sldl=41 if fcounty==137 & mcd=="Warren"
replace sldl=41 if fcounty==137 & mcd=="Wild Rose"
replace sldl=41 if fcounty==137 & mcd=="Marion"
replace sldl=41 if fcounty==137 & mcd=="Coloma"
replace sldl=41 if fcounty==137 & mcd=="Dakota"
replace sldl=71 if fcounty==137 & mcd=="Deerfield"
replace sldl=71 if fcounty==137 & mcd=="Hancock"
replace sldl=71 if fcounty==137 & mcd=="Oasis"
replace sldl=71 if fcounty==137 & mcd=="Plainfield"
replace sldl=41 if fcounty==137 & mcd=="Richford"
replace sldl=71 if fcounty==137 & mcd=="Rose"
replace sldl=41 if fcounty==137 & mcd=="Wautoma"

replace sldl=55 if (fcounty==139 & sldl==57) 
replace sldl=70 if (fcounty==141 & sldl==86) 
